﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FuLiao_GuanCai_DaoHuo_Search.aspx.cs" Inherits="syc.Sale.FuLiao_GuanCai_DaoHuo_Search" %>

<head id="Head1" runat="server">
    <title></title>    
</head>
<body>
    <script type="text/javascript" language="javascript" src="/common.js"></script>
     <form id="form2" runat="server">
    <div id="wintop" class="wintop">管材到货查询</div>
        <asp:Panel ID="Panel2" runat="server" CssClass="panel" GroupingText="查 询">
        供货单位：<asp:DropDownList ID="GongHuoDanWei" runat="server" 
            DataSourceID="SqlDataSource2" DataTextField="名称" DataValueField="ID" 
                Width="100px">
        </asp:DropDownList>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 辅&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 料：<asp:DropDownList ID="YuanCaiLiao" runat="server" 
            DataSourceID="SqlDataSource3" DataTextField="品名" DataValueField="ID">
        </asp:DropDownList><br />       
            车&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;号：<asp:TextBox ID="CheHao" runat="server" Width="110px"></asp:TextBox>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;炉&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 号：<asp:TextBox ID="LuHao" runat="server" Width="110px"></asp:TextBox>           
            <br/>
            开始日期：<asp:TextBox ID="Date1" runat="server" CssClass="intxt1" Width="110px"></asp:TextBox>
            <img align="middle" alt="" 
                onclick="makecalendar(document.getElementById('Date1').value, document.getElementById('Date1'));" 
                src="/Icons/29.png" />&nbsp;&nbsp; 结束日期：<asp:TextBox ID="Date2" runat="server" 
                CssClass="intxt1" Width="110px"></asp:TextBox>
            <img align="middle" alt="" 
                onclick="makecalendar(document.getElementById('Date2').value, document.getElementById('Date2'));" 
                src="/Icons/29.png" /> (以到货日期为筛选条件)
            <asp:Button ID="Button_Query" runat="server" CssClass="wsbutton" 
                onclick="Button_Query_Click" Text="筛选" UseSubmitBehavior="true" />
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                ConnectionString="<%$ ConnectionStrings:SCMConnectionString1 %>" 
                SelectCommand="SELECT 0 as [ID], '全部' as [名称] union SELECT [ID], [名称] FROM [原料供货单位]">
            </asp:SqlDataSource>
            <asp:Panel ID="Panel1" runat="server" CssClass="panel">
                <asp:Label ID="Label_Result" runat="server" ForeColor="Red" 
                    Text="请点击“筛选”按钮进行统计"></asp:Label>
            </asp:Panel>           
    </asp:Panel>
   
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SCMConnectionString1 %>" 
            SelectCommand="SELECT 0 as [ID], '全部' as [品名] union SELECT [ID], [品名] FROM [材料] where [品名]='套管成品接箍'">
        </asp:SqlDataSource>
     <asp:Panel ID="Panel3" runat="server" CssClass="panel2">
        <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt"></asp:Label>
    </asp:Panel>
     <div class="gridframe">
        <div class="gridview">
        
            <table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#e5cfab">
	            <tr>
		            <td class="grid-title">管材到货管理                        <asp:SqlDataSource  ID="SqlDataSource1" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:SCMConnectionString1 %>" 
                            SelectCommand="SELECT     dbo.管材到货登记.车号,dbo.原料供货单位.名称, dbo.原料.品名, dbo.管材到货明细.炉号, dbo.管材到货明细.批次, dbo.管材到货明细.重量,dbo.管材到货明细.磅重,dbo.管材到货明细.支数, dbo.管材到货明细.区域, 
                      dbo.管材到货登记.到货日期,dbo.管材到货登记.车号
                      FROM  dbo.管材到货登记 INNER JOIN
                      dbo.管材到货明细 ON dbo.管材到货登记.ID = dbo.管材到货明细.管材到货登记ID INNER JOIN
                      dbo.原料供货单位 ON dbo.管材到货登记.原料供货单位ID = dbo.原料供货单位.ID INNER JOIN
                      dbo.原料 ON dbo.管材到货明细.原料ID = dbo.原料.ID"
                           
                            >
                            </asp:SqlDataSource>
                         <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                             AutoGenerateColumns="False" CssClass="grid" 
                            DataSourceID="SqlDataSource1" 
                            GridLines="None" ondatabound="GridView1_DataBound" 
                            onpageindexchanged="GridView1_PageIndexChanged" AllowSorting="True" 
                            UseAccessibleHeader="False" Width="850px" >
                            <PagerSettings Visible="False" />
                            <RowStyle CssClass="grid-row-normal" />
                            <SelectedRowStyle   CssClass="grid-row-bright" />
                            <Columns>
                             <asp:TemplateField HeaderText="">
                                    <ItemTemplate>
                                        <asp:Button ID="Button1" runat="server" CommandName="Select" Text="选择" CssClass="hide"/>
                                        <img src="/Icons/online.gif" style="margin-top:2px;" alt="" />
                                    </ItemTemplate>
                                    <HeaderStyle CssClass="grid-header" />
                                    
                                    <ItemStyle CssClass="grid" HorizontalAlign="Center" Width="20px" />
                                </asp:TemplateField>
                                 
                                <asp:BoundField DataField="名称" HeaderText="名称" 
                                    ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                    ItemStyle-Width="100" >
                                <HeaderStyle CssClass="grid-header"></HeaderStyle>

                                <ItemStyle CssClass="grid" Width="100px"></ItemStyle>
                                                                </asp:BoundField>
                                
                              <asp:BoundField DataField="品名" HeaderText="品名" SortExpression="品名"
                                    ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                    ItemStyle-Width="80" >
                                <HeaderStyle CssClass="grid-header"></HeaderStyle>

                                <ItemStyle CssClass="grid" Width="80px"></ItemStyle>
                                                                </asp:BoundField>            
                                <asp:BoundField DataField="炉号" HeaderText="炉号" SortExpression="炉号" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField> 
                <asp:BoundField DataField="批次" HeaderText="批次" SortExpression="批次" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>        
                   <asp:BoundField DataField="重量" HeaderText="名义重量" SortExpression="重量" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>   
                <asp:BoundField DataField="磅重" HeaderText="实际重量" SortExpression="磅重" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>   
                   <asp:BoundField DataField="区域" HeaderText="存放区域" SortExpression="区域" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>    
                 <asp:BoundField DataField="车号" HeaderText="车号" SortExpression="车号" ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80px" ItemStyle-HorizontalAlign="Center" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>    
                <asp:BoundField DataField="到货日期" HeaderText="到货日期" SortExpression="到货日期"  
                    ItemStyle-CssClass="grid" HeaderStyle-CssClass="grid-header"
                                     ItemStyle-Width="80" ItemStyle-HorizontalAlign="Center" 
                    DataFormatString="{0:d}" >
                                    <HeaderStyle CssClass="grid-header"></HeaderStyle>
                <ItemStyle HorizontalAlign="Center" CssClass="grid" Width="80px"></ItemStyle></asp:BoundField>
                            </Columns>                      
                          </asp:GridView>
		            </td>
	            </tr>
	            <tr>
		            <td>   
		                 <table width="100%">
		                    <tr>
		                        <td class="pagebar">
                                    <asp:Button ID="Button_Pager_First" runat="server" Text="" ToolTip="首页" 
                                        CssClass="pageturn-first-b" onclick="Pager_Click" CommandName="--" />
                                    <asp:Button ID="Button_Pager_Prev" runat="server" Text="" ToolTip="上一页" 
                                        CssClass="pageturn-prev-b" onclick="Pager_Click" CommandName="-" />
                                    <input type="button" class="page-split" />第<asp:TextBox ID="TextBox_Pager" runat="server" CssClass="pageturn" 
                                        ontextchanged="Pager_Click"></asp:TextBox>页<input type="button" class="page-split" /><asp:Label ID="Label_Pages" runat="server"></asp:Label><input type="button" class="page-split" />
                                    
                                    <asp:Button ID="Button_Pager_Next" runat="server" Text="" ToolTip="下一页" 
                                        CssClass="pageturn-next-b" onclick="Pager_Click" CommandName="+" />
                                    <asp:Button ID="Button_Pager_Last" runat="server" Text="" ToolTip="末页" 
                                        CssClass="pageturn-last-b" onclick="Pager_Click" CommandName="++" />
                                </td>
                                <td align="right">
                                    <asp:Label ID="Label_Total" runat="server" CssClass="grid_totalrows"></asp:Label>
                                </td>
                            </tr>
                       </table>

		            </td>
	            </tr>
            </table>
            

        </div>
    </div>
    
    </form>
<script>
    var textboxs = document.getElementsByTagName("input");
    var i;
    for (i = 0; i < textboxs.length; i++) {
        if (textboxs[i].className == "textbox") {
            textboxs[i].onchange = function(e) { this.className = "textbox-changed"; };
            textboxs[i].onfocus = function(e) { this.select(); };
        }
        else if (textboxs[i].className == "pageturn" || textboxs[i].className == "intxt1" || textboxs[i].className == "intxt2") {
            textboxs[i].onfocus = function(e) { this.select(); };
        }

    }
    var rows = document.getElementsByTagName("tr");
    for (i = 0; i < rows.length; i++) {

        if (rows[i].className == "grid-row-normal") {
            rows[i].onmouseover = function() { this.className = "grid-row-bright"; };
            rows[i].onmouseout = function() { this.className = "grid-row-normal"; };
            rows[i].onclick = function() { this.firstChild.firstChild.click(); };
        }
    }
    var tds = document.getElementsByTagName("td");
    for (i = 0; i < tds.length; i++) {
        if (tds[i].className == "detailheader") {
            tds[i].innerHTML = tds[i].innerHTML.replace("*", "<span class=required>*</span>");
        }
    }
</script>
</body>
</html>
